﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace privateworking.DAO
{
    class Kucunguanli
    {
        //条件查询
        public Bean.Rukuguanli_yuancailiaoBean rukuguanli_yuancailiaoDaoSelectCondition(Bean.Rukuguanli_yuancailiaoBean bean)
        {
            DB.DBbase dbbase = new DB.DBbase();
            string sql = "";
            sql = "select * from rukuguanli where ruku_type = '0'";
            sql = sql + " and ruku_no= '" + bean.Ruku_no + "'";
            if (dbbase.ExecuteSQL(sql.Trim()))
            {
                if (dbbase.rows.Length != 0)
                {
                    bean.Selectresult = dbbase.rows;
                    bean.Resultclo = dbbase.Col_Number;
                    bean.Resultrow = dbbase.Row_Number;
                }
                else
                {
                    bean.Selectresult = null;
                }
            }
            else
            {
                bean.Selectresult = null;
            }
            return bean;
        }
    }
}
